-- =============================================
-- Author:		Rodrigo Martins
-- Create date: 14/11/2013
-- Description:	Inserir Dieta
-- =============================================
CREATE PROCEDURE ai_sp_inserirDieta
	@id int output,
	@academia varchar(60),
	@cliente varchar(60),
	@funcionario varchar(60),	
	@id_alimentacao int
	
AS
BEGIN
	INSERT INTO [Dieta]
       ([academia] 
       ,[cliente] 
       ,[funcionario] 
       ,[id_alimentacao]
       )

     VALUES
       (
	    @academia       
	   ,@cliente
	   ,@funcionario
           ,@id_alimentacao	         
       )
   select @id = @@IDENTITY

END
GO
